UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7OgWirPVlM2yZ86jNu99xeUHarRDXB6B5qn3iZOMu8='
WHERE
key_id = 'a255df405f40e98d029ef2845b5413a9f954e0ac37ad1bfa25b77e667e530678'
AND (
token = 'K7OgWirPVlM2yZ86jNu99xeUHarRDXB6B5qn3iZOMu8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)