UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gdMD0Ln9JlVglIzsiimnMd7xqW+tBI3koqmbLO0bm98='
WHERE
key_id = 'f967964cff1fb8cf874d19dd3d5ce220d469ceb6a5c33a57ed995189c77bff20'
AND (
token = 'gdMD0Ln9JlVglIzsiimnMd7xqW+tBI3koqmbLO0bm98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)