UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8JJ2OLCekNagei1gzKokhGdVi/gp2Re7f1Ii3ndfxM='
WHERE
key_id = '388e30682b7649a540f13b3876dad16851d31362840dbf2e62d45329b090ebe8'
AND (
token = 'N8JJ2OLCekNagei1gzKokhGdVi/gp2Re7f1Ii3ndfxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)