UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cXlaAes5QTOc8juvbp5uvVFUlpuIpOnG+92vjaKF4p8='
WHERE
key_id = 'd5a76f6fa5c998b30b16c68c489553b5e67a141457d6c5d5fbc8500c8b02c393'
AND (
token = 'cXlaAes5QTOc8juvbp5uvVFUlpuIpOnG+92vjaKF4p8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)