UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lcQvtcy1cejapv6Xr4ktmriR5lMMU3b1lPulP1r9tPw='
WHERE
key_id = '1a0598b24016f050fb411fd4e89aa4263d34aa81087adb600de92c6d1cb756df'
AND (
token = 'lcQvtcy1cejapv6Xr4ktmriR5lMMU3b1lPulP1r9tPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)