UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZAwMFuiUr6IvAZBWuyqHWUaVq391TNsXu7f6UmueCaE='
WHERE
key_id = 'e4a01aa0a38460b51cb3dd50a2cc2cd97a256b0dcf3fe78615f472227c0ef7b4'
AND (
token = 'ZAwMFuiUr6IvAZBWuyqHWUaVq391TNsXu7f6UmueCaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)