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