UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sTk1Es36ee3QR+mV8i9WAXsYSmrxYz+5v3TVE+XkkKU='
WHERE
key_id = 'f53238f7a595617f3cf8eabac74fd123716a5be0fa0c4aa39656d18a51da3ee6'
AND (
token = 'sTk1Es36ee3QR+mV8i9WAXsYSmrxYz+5v3TVE+XkkKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)