UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Qq/u6DjnQa11DfaV3UfYV9b2SWfsSUR5zYXpnZBbrA='
WHERE
key_id = '5b8ca9f0ac5967badef2d2678a77697c7af44a223fc87f345a7828f82344a8aa'
AND (
token = '/Qq/u6DjnQa11DfaV3UfYV9b2SWfsSUR5zYXpnZBbrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)