UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5fq8hdmSbeWXV6YVfwbvTGaUuwghP7wrr4Z2VywsBeE='
WHERE
key_id = '08e69f9cb0f5b1ade03ce6b0a49a3a843fe5d3a830be85846e2ea2385587a054'
AND (
token = '5fq8hdmSbeWXV6YVfwbvTGaUuwghP7wrr4Z2VywsBeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)