UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsW3gsq86cTw6IUcBT3cN4a4Yf7WArx2JZyVUztncAU='
WHERE
key_id = '02bfc6e439a00bbf90982365319b156373e2ba2af075af8340ac37336c3e3526'
AND (
token = 'zsW3gsq86cTw6IUcBT3cN4a4Yf7WArx2JZyVUztncAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)