UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P1p14V6k7YapfiYxaxvICQSTodHsdUB7fel8+IMWXV8='
WHERE
key_id = 'c97991b63679d0acfbced0f22d5963f163a6ad031556fc6ec299d4be87ede2db'
AND (
token = 'P1p14V6k7YapfiYxaxvICQSTodHsdUB7fel8+IMWXV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)