UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wbwftFkLz+7TTCluRBkX2dgaIR46vV66m+Vhe4bUT4U='
WHERE
key_id = 'd1959cfa026e784a7bd5e2307bb3ec66717a767c5b050f37810a193c4b663160'
AND (
token = 'wbwftFkLz+7TTCluRBkX2dgaIR46vV66m+Vhe4bUT4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)