UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnOCFmPe0PZziWkybFnf+lFHssIEZAQHKXKG+dySrZ0='
WHERE
key_id = 'ca81349e2a3fdae03d3617a4a961d05a0f5edb4c2488de3354045ea0559215fd'
AND (
token = 'pnOCFmPe0PZziWkybFnf+lFHssIEZAQHKXKG+dySrZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)