UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4BVe87A01V0Dw7uHzOvJIjRThuN/aNJHZUDA51g9fk='
WHERE
key_id = 'f70550ed7443b62545cb5d8a64e4627e4101a522414fbbca57f71df7c651461c'
AND (
token = 'X4BVe87A01V0Dw7uHzOvJIjRThuN/aNJHZUDA51g9fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)