UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SmAQLHsTqib9ldCB20WDTJr2ZuwTP5mhhkIccbaTtpU='
WHERE
key_id = '00fea0ca348a9f37e9659ff1f3f68169a611a4b10e20dcd8a2391b221abb0853'
AND (
token = 'SmAQLHsTqib9ldCB20WDTJr2ZuwTP5mhhkIccbaTtpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)