UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bDJwLum9Th+Ul11+iUTI74jvAiwjslmYnWjN+D67lDs='
WHERE
key_id = 'f574ffc110bd912104e27ee0d2e02c665a5f5cf6282789b63277734eedbf952b'
AND (
token = 'bDJwLum9Th+Ul11+iUTI74jvAiwjslmYnWjN+D67lDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)