UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1yD3EVjJX4NV0kSMf0E+eEtDj2aHsw1W41uzf3qxvM4='
WHERE
key_id = 'dc2c023a48a64b039d5885a933f895dc4b102e3dfcb5c4a3e62b9a29b9ac71ef'
AND (
token = '1yD3EVjJX4NV0kSMf0E+eEtDj2aHsw1W41uzf3qxvM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)