UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vRh/tFNeyW5BwBYdfU+W1vzFZNbBOspf/vKchklnj0s='
WHERE
key_id = '402508afa65a22c34964319433bb1897827611857e74793fc739a9da99b225a8'
AND (
token = 'vRh/tFNeyW5BwBYdfU+W1vzFZNbBOspf/vKchklnj0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)