UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fK9qh+13Y+rBibzNS7YecQFreZuzi2Ln5sNlHeW/Iyk='
WHERE
key_id = 'd25e23ec9dfa16c8126f65f7857810d834b492af8c684991aa018f3fff97825a'
AND (
token = 'fK9qh+13Y+rBibzNS7YecQFreZuzi2Ln5sNlHeW/Iyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)