UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'twCIpU8phbVueII22HVxAK6gaSLEK2Jlm3x3H5JBswA='
WHERE
key_id = '49c0aeb02e3d710280fae806a85c75c0c723adc0e760bf4d4feddcb36d2d9c82'
AND (
token = 'twCIpU8phbVueII22HVxAK6gaSLEK2Jlm3x3H5JBswA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)