UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Te31ieXcw8C/kpBp2RD17zt46w7/8/NpJ/Q/j8ACB+w='
WHERE
key_id = 'd50fe4afada6d7b2e4262d2653dc3a00b124235c51e575572da1b519c7709491'
AND (
token = 'Te31ieXcw8C/kpBp2RD17zt46w7/8/NpJ/Q/j8ACB+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)