UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V0Xlsxaqewlb0jfO7Q6g8byjSqb/6aQCy1Sv97RmJbo='
WHERE
key_id = '20ef58cbe64ccda59c73e5bc4e2f8a7e18eaa5ed29dca73036f1a5ffc5dbd027'
AND (
token = 'V0Xlsxaqewlb0jfO7Q6g8byjSqb/6aQCy1Sv97RmJbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)