UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zHbqkvuMgB8dPfLdhs0ZaTYHNyq54NpeOQ2ryuJ5kFU='
WHERE
key_id = 'a108d97b95abe7367a0dd3b288b472ee6678c05a07243639c5f5b6a39529a41a'
AND (
token = 'zHbqkvuMgB8dPfLdhs0ZaTYHNyq54NpeOQ2ryuJ5kFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)