UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3mHj/lETndlBP99MeIz2ICp9Y3w8YKG5e5oWjT4pVVg='
WHERE
key_id = 'aca1b732387408c2eca6b2bbfc2e5e62f58ad867af1454958e45b376179fa324'
AND (
token = '3mHj/lETndlBP99MeIz2ICp9Y3w8YKG5e5oWjT4pVVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)