UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'irTwQo7MtazsqyoN6B5JED9TRqXFEjS5KHAN6i7wutI='
WHERE
key_id = '44f2fee84db582fad56e46fee4c53fa31f966b987b1a563c2fdf9938398ae82a'
AND (
token = 'irTwQo7MtazsqyoN6B5JED9TRqXFEjS5KHAN6i7wutI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)