UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kWVFVwI4e7cUzcQ3YsseceFlds6gzfeT99XMh5WHa30='
WHERE
key_id = '38a54b54f8ad7ea2692111ef8758b52de6fd9b9762049cd833d0b2f898058f7b'
AND (
token = 'kWVFVwI4e7cUzcQ3YsseceFlds6gzfeT99XMh5WHa30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)