UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5geKX7vJsfObua36odx951eqQtXARwze8rL0Ii/rNyY='
WHERE
key_id = '7747b4b51ef946794317d447d7f8f95082a146af4b55f82d90bc584f9203f82d'
AND (
token = '5geKX7vJsfObua36odx951eqQtXARwze8rL0Ii/rNyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)