UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2lifPm0VhFGmatcBO69tMJJvG4nakNZwsm3kHwly/Q4='
WHERE
key_id = '07ffdbcef90be023e7fedd68560813cead5ccf80a9fe7fa2d029f3ba224bb24e'
AND (
token = '2lifPm0VhFGmatcBO69tMJJvG4nakNZwsm3kHwly/Q4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)