UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8vsqNfG+wkPERSdG1RwpfsOf3HWskEtDkhSgVUVtF+8='
WHERE
key_id = '9fef8459b7ffad2b983af41d998a8723119d6c65cccd3370c5df1889978b983c'
AND (
token = '8vsqNfG+wkPERSdG1RwpfsOf3HWskEtDkhSgVUVtF+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)