UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N55hOaZ/wVezb4aUaOGkizxRpq9ZsZwJxiym3yFxkCY='
WHERE
key_id = 'a1383b6b48e17b055343a45158b7edd3789b159da364e327d25d24ea591e1704'
AND (
token = 'N55hOaZ/wVezb4aUaOGkizxRpq9ZsZwJxiym3yFxkCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)