UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WdV3j6RfXhMZGw54FeXmt7WIDVu2VgasMgM0aKH0Rlw='
WHERE
key_id = '96949bb0bea8849ecb698b0d1c837c8bd3f19bb4f36e5bb095961927e90de8b3'
AND (
token = 'WdV3j6RfXhMZGw54FeXmt7WIDVu2VgasMgM0aKH0Rlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)