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