UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8zToJ+4a9V44XsFpekwAsANI9wpBFmKA25oBGNYBxw='
WHERE
key_id = 'd9d51aa7449a9209efb3fbf16f6d48e903bfad9bcd25d198a925162d9733bdbf'
AND (
token = 'r8zToJ+4a9V44XsFpekwAsANI9wpBFmKA25oBGNYBxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)