UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47PIAHy+RB006tSMG0zgpQL1TITSI9uWxrGrguZy+u4='
WHERE
key_id = '2048dd4c8e69cfb36f0b8bf74d05d5d983343328c1115ac100a68993e71dfe35'
AND (
token = '47PIAHy+RB006tSMG0zgpQL1TITSI9uWxrGrguZy+u4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)