UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qJOCwNVWwLnjR8i7Ezx4/p2KLQu690J08T2724ug044='
WHERE
key_id = '74a81373d2f97deddef8547c0654ca35c2cf6f2b036c51f00de45c17c22dfe0e'
AND (
token = 'qJOCwNVWwLnjR8i7Ezx4/p2KLQu690J08T2724ug044='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)