UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pz0TA9+3fu9uB4g6+wQ8eK+ihPMPy2Nar0f0jAMku2w='
WHERE
key_id = '46c33559869ab6cc8129f33d2f952caa4313a8201d3e899174b091c587a657de'
AND (
token = 'Pz0TA9+3fu9uB4g6+wQ8eK+ihPMPy2Nar0f0jAMku2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)